import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;

import jxl.*; 
public class main{
    
	
	public static void main(String[] args) {
  	 Long time1= new Date().getTime();
    	 ArrayList<String> excelListItem = new ArrayList<String>(); 
    	 ArrayList<String> dataClass_1 = new ArrayList<String>();
    	 ArrayList<String> dataClass_2 = new ArrayList<String>();
    	 ArrayList<String> dataClass_3 = new ArrayList<String>();
    	 ArrayList<String> dataClass_4 = new ArrayList<String>();
    	 String filePath = "./res/181010316.xls";
    	 excelListItem = readFromExcel.ExcelToList(filePath);
    	 
    	 
    	 dataClass_1 = excelDataClass.DateClass_One(excelListItem);
    	 dataClass_2 = excelDataClass.DataClass_Two(excelListItem);
    	 dataClass_3 = excelDataClass.DataClass_Third(excelListItem);
    	 dataClass_4 = excelDataClass.DataClass_Four(excelListItem);
     
    	 //for(String s:dataClass_2){
    	//	 System.out.println(s);
    	// }
    	 
    	// dataClass.clear();
    	// dataClass = excelDataClass.DataClass_Two(excelListItem);
    	// for(String s:dataClass){
    		 //System.out.println(s);
    	// }
    	 
    	 //dataClass.clear();
    	// dataClass = excelDataClass.DataClass_Third(excelListItem);
    	// for(String s:dataClass){
    		 //System.out.println(s);
    	// }
    	 
    	 try {
 			new dataClassToExcel().toNewExcel(dataClass_1,dataClass_2,dataClass_3,dataClass_4);
 		} catch (Exception e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		};
     Long time2 = new Date().getTime();
     Long t= time2-time1;
     System.out.println(t);
             	
    }
}